from openpyxl import load_workbook  # 读取excel文件

# 数据起始行
data_row_start = 2
# 数据终止行
data_row_end = 108


def discretization():
    """
    数据离散化
    :return:
    """
    # file_url 文件地址
    file_url = "/Users/wangweijie/workspace/python/mltest/decision-tree/data/Sepsis_Interpolation_Done.xlsx"
    # sheet_name 需要操作的sheet名称
    sheet_name = "Sepsis"
    #  获取需要操作的数据
    wb = load_workbook(file_url, data_only=True)


def body_temperature(data):
    """
    体温离散化
    :param data:
    :return:
    """
    for day_index in range(0, 14, 1):
        # 基础增长列
        data_column = 24 + 14 * day_index + 1
        data_value = data.cell(column=data_column, row=row_index).value


if __name__ == '__main__':
    print("test")
